package com.xinsoft.mapper;

import com.xinsoft.entity.po.ScmSalePrice;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xinsoft.entity.vo.ScmSalePriceVo;
import org.springframework.data.repository.query.Param;

/**
 * @author ZYM
 * @description 针对表【scm_sale_price(物料销售价格明细)】的数据库操作Mapper
 * @createDate 2023-07-17 09:57:33
 * @Entity com.xinsoft.entity.po.ScmSalePrice
 */
public interface ScmSalePriceMapper extends BaseMapper<ScmSalePrice> {

    /**
     * 最近三次历史价格
     *
     * @param clientId   客户id
     * @param materialId 物料id
     * @return {@link ScmSalePriceVo}
     */
    ScmSalePriceVo historyPrice(@Param("clientId") Integer clientId, @Param("materialId") Integer materialId);
}




